表数据 将group by 后重复的数据拼接起来 SELECT t.job, wmsys.wm_concat(t.ename) as naems, count(1) FROM emp t GROUP BY t.job; 将多行数据转为一行数据 select wm_concat(t.ename) names from emp t;